Hi, This is a column prompt in a dashboard prompt. So you cannot add a number format with zero decimal places as suggested like you can on a column in an analysis. My solution would be to add a funct…

Thanks Mihaela, I will give it a go :)

For example in this query your persons with multiple assignments will float to the top... do you have any with multiple primary active employee assignments at the same point in time? select all count…

Hi, Yes a person may have many assignments at the same point it time and for each assignment id many instances (updates) of that assignment id over time including multiple update in the same day. Per…

No but you can add a union to select a constant from a subject area that you know will only return 1 row. (select all 0 as s_0, "presentation table"."presentation column" as s fro…